<table border="1">
  <tr>
    <td>client_id</td>
    <td>user</td>
    <td>pass</td>
    <td>pri_email</td>
    <td>company_name</td>
    <td>type_id</td>
    <td>enabled</td>
    <td>pending_new</td>
    <td>locamedic_client_number</td>
    <td>csss_parent_id</td>
    <td>medipoints</td>
    <td>name</td>
    <td>phone</td>
    <td>fax</td>
    <td>adresse</td>
    <td>ville</td>
    <td>province</td>
    <td>zip</td>
    <td>country</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_adsf['client_id']; ?></td>
      <td><?php echo $row_adsf['user']; ?></td>
      <td><?php echo $row_adsf['pass']; ?></td>
      <td><?php echo $row_adsf['pri_email']; ?></td>
      <td><?php echo $row_adsf['company_name']; ?></td>
      <td><?php echo $row_adsf['type_id']; ?></td>
      <td><?php echo $row_adsf['enabled']; ?></td>
      <td><?php echo $row_adsf['pending_new']; ?></td>
      <td><?php echo $row_adsf['locamedic_client_number']; ?></td>
      <td><?php echo $row_adsf['csss_parent_id']; ?></td>
      <td><?php echo $row_adsf['medipoints']; ?></td>
      <td><?php echo $row_adsf['name']; ?></td>
      <td><?php echo $row_adsf['phone']; ?></td>
      <td><?php echo $row_adsf['fax']; ?></td>
      <td><?php echo $row_adsf['adresse']; ?></td>
      <td><?php echo $row_adsf['ville']; ?></td>
      <td><?php echo $row_adsf['province']; ?></td>
      <td><?php echo $row_adsf['zip']; ?></td>
      <td><?php echo $row_adsf['country']; ?></td>
    </tr>
    <?php } while ($row_adsf = mysql_fetch_assoc($adsf)); ?>
</table>
<?php require_once('Connections/locamedicadmin.php'); ?>
<?php
$maxRows_adsf = 10;
$pageNum_adsf = 0;
if (isset($_GET['pageNum_adsf'])) {
  $pageNum_adsf = $_GET['pageNum_adsf'];
}
$startRow_adsf = $pageNum_adsf * $maxRows_adsf;

mysql_select_db($database_locamedicadmin, $locamedicadmin);
$query_adsf = "SELECT * FROM csre_client";
$query_limit_adsf = sprintf("%s LIMIT %d, %d", $query_adsf, $startRow_adsf, $maxRows_adsf);
$adsf = mysql_query($query_limit_adsf, $locamedicadmin) or die(mysql_error());
$row_adsf = mysql_fetch_assoc($adsf);

if (isset($_GET['totalRows_adsf'])) {
  $totalRows_adsf = $_GET['totalRows_adsf'];
} else {
  $all_adsf = mysql_query($query_adsf);
  $totalRows_adsf = mysql_num_rows($all_adsf);
}
$totalPages_adsf = ceil($totalRows_adsf/$maxRows_adsf)-1;

mysql_free_result($adsf);
?>
